Goal-oriented dynamic buffer pool management for data base systems

This paper presents a technique for performing dynamic goal oriented buuer pool management for database management systems. To dynamically adjust the buuer pool sizes for the multiple buuer pools provided by database management systems is a complex constrained optimization problem. In the goal oriented approach, the user speciies each buuer pool's random access response time goal and the total available number of buuers for all buuer pools. The problem is to dynamically expand or contract the buuer pool sizes based on the database workload to achieve these pre-deened response time goals for each buuer pool while maintaining the same total number of buuers in the database system. Our goal satisfaction algorithm monitors goal satisfaction of each buuer pool and periodically changes buuer pool sizes to improve goal satisfaction. The expanding and contracting process does not allocate new or free up existing virtual storage. We demonstrate that dynamic tuning can greatly improve buuer pool goal satisfaction through trace driven simulations.